<%@page import="java.sql.*"%>
<html>
<head>
<title>Obtaining a Connection</title>
</head>
<body>
<h1>This Page Obtains a Connection to a Database and executes a query</h1>
<%
    Connection conn = null;
    ResultSet result = null;
    Statement stmt = null;


    try {
      Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (Exception e) {
      System.out.println("Error occurred " + e);
     }
     try {
       conn = DriverManager.getConnection("jdbc:odbc:PPL", "","");
     }
     catch (SQLException e) {
        System.out.println("Error occurred " + e);
     }
     /*try {
        stmt = conn.createStatement();
        result = stmt.executeQuery("SELECT * FROM PPL");
     }
     catch (SQLException e) {
         System.out.println("Error occurred " + e);
      }*/

%>